from cgi import print_directory
import openpyxl

wb = openpyxl.load_workbook(r"F:\my_profile\study\code_pub\study_code_pub\python表格\index.xlsx")
print(wb.sheetnames)

# 获取表单
for _i in wb:
    print(_i)
    print(_i.title)